The 6th part of the training SQL.
What you will see in this video:
- How to use mathematical functions in databases such as COUNT, SUM, AVG and...
- Limit the number of selected lines with LIMIT or TOP
- Sort rows in ascending or descending order in the table
- Teaching the concept of AS and setting aliases for columns
- How to paste several columns together and create a new column